Show All

Save styles to use in new workbooks

1. Open a new blank workbook.
2. Open the workbook that contains the styles you want to save.
3. Copy the styles from your workbook to the blank workbook.

   How?

   1. Open the workbook that contains the styles you want to copy.
   2. Open the workbook you want to copy the styles to, and then click Style on the Format menu.
   3. Click Merge.
   4. In the Merge styles box, double-click the workbook that contains the styles you want to copy.

   Note  If the two workbooks contain styles with the same names, you must confirm that you want to merge these styles. To replace the styles in the active workbook with the copied styles, click Yes. To keep the styles in the active workbook, click No. This warning occurs only once, regardless of the number of conflicting style names.

4. In the blank workbook, click Save As on the File menu.
5. In the File name box, type book.
6. In the Save as type list, click Template (*.xlt).
7. In the Save in list, click the Templates folder.
8. Click Save.

   Note  The styles you save will be available in all new workbooks that you subsequently create by clicking New .